Apple Reference & Presen…tion Library 1994 January/ARPL-Jan94-Disc2of2-Partner-Edition.iso/Applications/Databases/GQL V3.1 Demo Folder/USA Sales Information/USA Sales Information.rsrc/gDEM_19439_Sales by City

Text File | 1993-07-07 | 156 b | 1 lines

select customer.cust_city, AVG (orders.ord_amount) from customer, orders  where customer.cust_num = orders.cust_nr group by customer.cust_city order by 1 ;